If then formula with date
Closed
Jyoungblood
Posts
1
Registration date
Thursday June 18, 2015
Status
Member
Last seen
June 18, 2015
-
Jun 18, 2015 at 09:55 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 23, 2015 at 10:59 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 23, 2015 at 10:59 AM
Related:
- If then formula with date
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Credit summation formula - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jun 22, 2015 at 11:05 AM
Jun 22, 2015 at 11:05 AM
Hi Jyoungblood,
How would Excel know what the next due date is?
Formula in A6 would be something like:
=IF(C5<>"","Next due date","")
Best regards,
Trowa
How would Excel know what the next due date is?
Formula in A6 would be something like:
=IF(C5<>"","Next due date","")
Best regards,
Trowa
Still not quite there. If c5 is blank, I want a6 to remain blank. If c5 has a date in it, I want a6 to add 3 days to c5 and then place that date in a6. Thanks
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jun 23, 2015 at 10:59 AM
Jun 23, 2015 at 10:59 AM
Hi Jyoungblood,
Of course we are not there yet! Because you didn't provide all the info. I can't read minds you know!
Formula in A6 will now be:
=IF(C5<>"",C5+3,"")
Best regards,
Trowa
Of course we are not there yet! Because you didn't provide all the info. I can't read minds you know!
Formula in A6 will now be:
=IF(C5<>"",C5+3,"")
Best regards,
Trowa
