Help

Re: A date formula!

1037 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Micheal_Ward
6 - Interface Innovator
6 - Interface Innovator

Maybe its the new year but I am having a trouble trying to work this out. :slightly_smiling_face:

I need a cell to work out 7 postal days from a specified date and add it to a number based on a date column.

for example.

date column has the date of today entered. 16th jan. 7 working days from today makes that the 27th Jan then it needs to add on another 14 calendar days and display the date it works out.

Im scratching my head here! lol

thanks all!

2 Replies 2
Micheal_Ward
6 - Interface Innovator
6 - Interface Innovator

I think I solved some of it…

DATEADD(WORKDAY({Date Of Termo issued},7), 14, ‘days’)

I had it backwards and tried to work the 7 days first instead of adding the 14 days to the worked out 7 days date.

But I now get an error statement if the date of termo field is blank…

Solved…

IF({Date Of Termo issued}, DATEADD(WORKDAY({Date Of Termo issued},7), 14, ‘days’))

now Im happy. :slightly_smiling_face: