Hi all,
Trying to get a formula to go into Column C. For row 2, I'd like the number of days between A2 and B2, but in row 3, the number of days between A3 and today's current date. If I could have one formula so I can drag it down the entire column, it would be great. Thank you!
Try putting the +1 within the final parentheses, like this:
=IF(ISBLANK(A2),"",DATEDIF(A2,MIN(B2,TODAY()),"D")+1)
SG
If I understand you correctly I think this will give you what what you want:
In C2, filled down:
=IF(ISBLANK(A2),"",DATEDIF(A2,MIN(B2,TODAY()),"D"))
Use ; instead of , in the formula if your region uses , as the decimal separator.
SG
Yes, that's exactly what I wanted, thank you very much. How would I add 1 day to the formula, for example, it's Monday 3rd today and currently showing as 0 days. I added a +1 to the end which works for that line itself, but when dragging down to other lines, it comes up with an error.
Thank you, that's perfect.
Working out dates on Numbers document
