Create Date Column

[spandy34]

Within Power Query, I need to create a new date column called Planned Exit Date that calculates as below:-

If [PlannedExitTime] (time format) is less than [PlannedEntryTime] (time format) then +1 day to [PlanndVisitDate]

Can someone please help me?

[Einomi · Accepted solution]

try 

If ... then Date.AddDays([PlannedVisitDate],1) else ...

[spandy34]

Thank you that has worked - I really appreciate your help @Greg_Deckler @Einomi 

[Greg_Deckler]

@spandy34 Maybe:

= if [PlannedExitTime] < [PlannedEntryTime] then [PlannedVisitDate] + 1 else [PlannedExitTime]

[spandy34]

Hi @Greg_Deckler 

I get this error