Skip to main content

Adding Days to a Date

  • September 28, 2018
  • 4 replies
  • 49 views

Lawrence_Ames
Forum|alt.badge.img+5

Column A has a Date. I want column B to be the Date in Column A + 18 days.

I can’t figure out how do to this. Help!

Lawrence

This topic has been closed for replies.

4 replies

Forum|alt.badge.img+17

You have DATEADD function:


Lawrence_Ames
Forum|alt.badge.img+5
  • Author
  • Known Participant
  • September 28, 2018

I did that, it only sort of works – it adds the date and the time.

I just want the Date shown.

Possible? Thank you!


Forum|alt.badge.img+18

I did that, it only sort of works – it adds the date and the time.

I just want the Date shown.

Possible? Thank you!


Use the “Formatting” menu in the field options to remove the time display.


Lawrence_Ames
Forum|alt.badge.img+5
  • Author
  • Known Participant
  • September 28, 2018

THANK YOU!! Ugh, I’m such a rookie. Thank you!